+---------------------------------------+
| CHARACTER_SETS                        |
| COLLATIONS                            |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| COLUMNS                               |
| COLUMN_PRIVILEGES                     |
| ENGINES                               |
| EVENTS                                |
| FILES                                 |
| GLOBAL_STATUS                         |
| GLOBAL_VARIABLES                      |
| KEY_COLUMN_USAGE                      |
| PARAMETERS                            |
| PARTITIONS                            |
| PLUGINS                               |
| PROCESSLIST                           |
| PROFILING                             |
| REFERENTIAL_CONSTRAINTS               |
| ROUTINES                              |
| SCHEMATA                              |
| SCHEMA_PRIVILEGES                     |
| SESSION_STATUS                        |
| SESSION_VARIABLES                     |
| STATISTICS                            |
| TABLES                                |
| TABLESPACES                           |
| TABLE_CONSTRAINTS                     |
| TABLE_PRIVILEGES                      |
| TRIGGERS                              |
| USER_PRIVILEGES                       |
| VIEWS                                 |
| INNODB_CMP_RESET                      |
| INNODB_TRX                            |
| INNODB_CMPMEM_RESET                   |
| INNODB_LOCK_WAITS                     |
| INNODB_CMPMEM                         |
| INNODB_CMP                            |
| INNODB_LOCKS                          |
+---------------------------------------+
37 rows in set (0.01 sec)

mysql> select * FROM character_sets;
+--------------------+----------------------+-----------------------------+-----
---+
| CHARACTER_SET_NAME | DEFAULT_COLLATE_NAME | DESCRIPTION                 | MAXL
EN |
+--------------------+----------------------+-----------------------------+-----
---+
| big5               | big5_chinese_ci      | Big5 Traditional Chinese    |
 2 |
| dec8               | dec8_swedish_ci      | DEC West European           |
 1 |
| cp850              | cp850_general_ci     | DOS West European           |
 1 |
| hp8                | hp8_english_ci       | HP West European            |
 1 |
| koi8r              | koi8r_general_ci     | KOI8-R Relcom Russian       |
 1 |
| latin1             | latin1_swedish_ci    | cp1252 West European        |
 1 |
| latin2             | latin2_general_ci    | ISO 8859-2 Central European |
 1 |
| swe7               | swe7_swedish_ci      | 7bit Swedish                |
 1 |
| ascii              | ascii_general_ci     | US ASCII                    |
 1 |
| ujis               | ujis_japanese_ci     | EUC-JP Japanese             |
 3 |
| sjis               | sjis_japanese_ci     | Shift-JIS Japanese          |
 2 |
| hebrew             | hebrew_general_ci    | ISO 8859-8 Hebrew           |
 1 |
| tis620             | tis620_thai_ci       | TIS620 Thai                 |
 1 |
| euckr              | euckr_korean_ci      | EUC-KR Korean               |
 2 |
| koi8u              | koi8u_general_ci     | KOI8-U Ukrainian            |
 1 |
| gb2312             | gb2312_chinese_ci    | GB2312 Simplified Chinese   |
 2 |
| greek              | greek_general_ci     | ISO 8859-7 Greek            |
 1 |
| cp1250             | cp1250_general_ci    | Windows Central European    |
 1 |
| gbk                | gbk_chinese_ci       | GBK Simplified Chinese      |
 2 |
| latin5             | latin5_turkish_ci    | ISO 8859-9 Turkish          |
 1 |
| armscii8           | armscii8_general_ci  | ARMSCII-8 Armenian          |
 1 |
| utf8               | utf8_general_ci      | UTF-8 Unicode               |
 3 |
| ucs2               | ucs2_general_ci      | UCS-2 Unicode               |
 2 |
| cp866              | cp866_general_ci     | DOS Russian                 |
 1 |
| keybcs2            | keybcs2_general_ci   | DOS Kamenicky Czech-Slovak  |
 1 |
| macce              | macce_general_ci     | Mac Central European        |
 1 |
| macroman           | macroman_general_ci  | Mac West European           |
 1 |
| cp852              | cp852_general_ci     | DOS Central European        |
 1 |
| latin7             | latin7_general_ci    | ISO 8859-13 Baltic          |
 1 |
| utf8mb4            | utf8mb4_general_ci   | UTF-8 Unicode               |
 4 |
| cp1251             | cp1251_general_ci    | Windows Cyrillic            |
 1 |
| utf16              | utf16_general_ci     | UTF-16 Unicode              |
 4 |
| cp1256             | cp1256_general_ci    | Windows Arabic              |
 1 |
| cp1257             | cp1257_general_ci    | Windows Baltic              |
 1 |
| utf32              | utf32_general_ci     | UTF-32 Unicode              |
 4 |
| binary             | binary               | Binary pseudo charset       |
 1 |
| geostd8            | geostd8_general_ci   | GEOSTD8 Georgian            |
 1 |
| cp932              | cp932_japanese_ci    | SJIS for Windows Japanese   |
 2 |
| eucjpms            | eucjpms_japanese_ci  | UJIS for Windows Japanese   |
 3 |
+--------------------+----------------------+-----------------------------+-----
---+
39 rows in set (0.00 sec)

mysql> DESC character_sets;
+----------------------+-------------+------+-----+---------+-------+
| Field                | Type        | Null | Key | Default | Extra |
+----------------------+-------------+------+-----+---------+-------+
| CHARACTER_SET_NAME   | varchar(32) | NO   |     |         |       |
| DEFAULT_COLLATE_NAME | varchar(32) | NO   |     |         |       |
| DESCRIPTION          | varchar(60) | NO   |     |         |       |
| MAXLEN               | bigint(3)   | NO   |     | 0       |       |
+----------------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> SHOW ENGINES;
+--------------------+---------+------------------------------------------------
----------------+--------------+------+------------+
| Engine             | Support | Comment
                | Transactions | XA   | Savepoints |
+--------------------+---------+------------------------------------------------
----------------+--------------+------+------------+
| FEDERATED          | NO      | Federated MySQL storage engine
                | NULL         | NULL | NULL       |
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables
                | NO           | NO   | NO         |
| MyISAM             | YES     | MyISAM storage engine
                | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to
 it disappears) | NO           | NO   | NO         |
| CSV                | YES     | CSV storage engine
                | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for tempor
ary tables      | NO           | NO   | NO         |
| ARCHIVE            | YES     | Archive storage engine
                | NO           | NO   | NO         |
| InnoDB             | DEFAULT | Supports transactions, row-level locking, and f
oreign keys     | YES          | YES  | YES        |
| PERFORMANCE_SCHEMA | YES     | Performance Schema
                | NO           | NO   | NO         |
+--------------------+---------+------------------------------------------------
----------------+--------------+------+------------+
9 rows in set (0.00 sec)

mysql> SHOW ENGINES;
+--------------------+---------+------------------------------------------------
----------------+--------------+------+------------+
| Engine             | Support | Comment
                | Transactions | XA   | Savepoints |
+--------------------+---------+------------------------------------------------
----------------+--------------+------+------------+
| FEDERATED          | NO      | Federated MySQL storage engine
                | NULL         | NULL | NULL       |
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables
                | NO           | NO   | NO         |
| MyISAM             | YES     | MyISAM storage engine
                | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to
 it disappears) | NO           | NO   | NO         |
| CSV                | YES     | CSV storage engine
                | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for tempor
ary tables      | NO           | NO   | NO         |
| ARCHIVE            | YES     | Archive storage engine
                | NO           | NO   | NO         |
| InnoDB             | DEFAULT | Supports transactions, row-level locking, and f
oreign keys     | YES          | YES  | YES        |
| PERFORMANCE_SCHEMA | YES     | Performance Schema
                | NO           | NO   | NO         |
+--------------------+---------+------------------------------------------------
----------------+--------------+------+------------+
9 rows in set (0.00 sec)

mysql> SHOW ENGINES;
+--------------------+---------+--------------------------------------------------------------
--+--------------+------+------------+
| Engine             | Support | Comment
  | Transactions | XA   | Savepoints |
+--------------------+---------+--------------------------------------------------------------
--+--------------+------+------------+
| FEDERATED          | NO      | Federated MySQL storage engine
  | NULL         | NULL | NULL       |
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables
  | NO           | NO   | NO         |
| MyISAM             | YES     | MyISAM storage engine
  | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears
) | NO           | NO   | NO         |
| CSV                | YES     | CSV storage engine
  | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables
  | NO           | NO   | NO         |
| ARCHIVE            | YES     | Archive storage engine
  | NO           | NO   | NO         |
| InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys
  | YES          | YES  | YES        |
| PERFORMANCE_SCHEMA | YES     | Performance Schema
  | NO           | NO   | NO         |
+--------------------+---------+--------------------------------------------------------------
--+--------------+------+------------+
9 rows in set (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| anil               |
| as                 |
| cdcol              |
| mysql              |
| nb158g12345        |
| performance_schema |
| phpmyadmin         |
| test               |
| webauth            |
+--------------------+
10 rows in set (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| anil               |
| as                 |
| cdcol              |
| mysql              |
| nb158g12345        |
| performance_schema |
| phpmyadmin         |
| test               |
| webauth            |
+--------------------+
10 rows in set (0.00 sec)

mysql> use nb158g12345;
Database changed
mysql> show tables;
+-----------------------+
| Tables_in_nb158g12345 |
+-----------------------+
| users                 |
+-----------------------+
1 row in set (0.00 sec)

mysql> select * FROM users;
ERROR 1146 (42S02): Table 'nb158g12345.users' doesn't exist
mysql> use nb158g;
Database changed
mysql> select * FROM users;
+----+-----------+----------------------+-----------+---------------------+-------------------
--+--------+
| id | name      | email                | password  | created_date        | modified_date
  | status |
+----+-----------+----------------------+-----------+---------------------+-------------------
--+--------+
|  4 | Test USer | test@gmail.com       | xyz123    | 2013-10-07 09:46:35 | 2013-10-07 09:46:3
5 | 0      |
|  5 | vikas     | vikas.nice@gmail.com | 123qwerty | 2013-10-07 09:46:42 | 2013-10-07 09:46:4
2 | 1      |
+----+-----------+----------------------+-----------+---------------------+-------------------
--+--------+
2 rows in set (0.00 sec)

mysql> drop users;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to
 your MySQL server version for the right syntax to use near 'users' at line 1
mysql> drop table users;
Query OK, 0 rows affected (0.08 sec)

mysql> select * FROM users;
ERROR 1146 (42S02): Table 'nb158g.users' doesn't exist
mysql>
